Labels:text | screenshot | menu OCR: Warehouse Lite Warehouse Deluxe Warehouse Supreme Scope One or two application areas Cross-department applications; multiple subject areas Enterprisewide; possibly interenterprise {for example, accounting, contract management, and sales) Model Subset of production data Syntactical/semantic mismatch resolution Highly complex schema Denormalization-based restructuring Moderately complex schema Drawn from cross-enterprise and external data sources Minor data scrubbing Ad hoc-based with formalization of commonly OLAP model; complex queries; multimedia data Mixture of production reports and used reports nto libraries ad hoc access lient Reporting (data access) tools Complex reporting tools (for example, browsing, Complex OLAP tools Simple usage, query based drill-down, and so on) Client empowerment to define and Data structures fully defined for users, Simple workflow/routing/groupware component populate local or regional data structures change requests centrally controlled by IS department Middleware Little or none Some replication, data pumping, other middleware Deluxe, state-of-the-art set of distributed Simple flat transactions Transaction models are mostly flat, but some are more computing services (for example, replication complex (for example, chained subtransactions. services, messaging, workflow, asynchronous delivery of partial results, and so on) distributed security, complex distributed Some directory services transaction management, and so on) Server Single DBMS engine; relational Multiple database servers, possibly multiple DBMS Distributed warehouse/data mart Any type of server box products approach; "federated" look Centralized warehouse, possibly with pockets of MPP likely distribution Multiple products/data models (for example, relational, text, OO/extended relational, and so on) FIGURE 1. The three-tiered taxonomy of major classes of data warehousing architectures.
